Release 10.1A: OpenEdge Reporting:
Query/Results Administration and Development
User management
User IDs let you manage user activities and provide services to users in Results. A user ID is a unique identifier assigned to a system user when the user logs onto the system. Most user IDs have an associated password.
Results uses user IDs to create and maintain query directories that store information about the queries that a user creates in Results. The following sections describe user IDs and how Results uses them to create and maintain query directories.
User IDs
User IDs can originate from a variety of sources. Many operating systems support and establish user IDs for system users. On most operating systems, Results can use the operating system user ID as an identifier for a Results user. For more information about user IDs, consult the system administration documentation for your operating system.
![]()
To create portable user IDs and passwords in a database, choose Admin
Security
Edit User List in the Data Administration tool.
A user ID for a user overrides any existing operating system user ID for the user. The user ID definitions must exist in the first database connected for an OpenEdge session. Once an OpenEdge database contains a user definition, an application cannot connect to the database without specifying a valid user ID and password combination. By default, Progress prompts for a valid user ID and password when Results connects to a database that contains user definitions.
There are several other ways to specify a valid user ID and password combination when you connect to a database. See the OpenEdge Development: Progress 4GL Handbook and OpenEdge Getting Started: Installation and Configuration for more information about user IDs and database connections.
If you are using an operating system that does not support user IDs and there are no defined OpenEdge users in the connected OpenEdge databases, your Results user ID is the blank user ID. As with any other user ID in Results, you can use feature security to restrict the access of the blank user ID to Results functionality.
Query directories
A query directory is a file that contains up to 256 query definitions for use by one or more Results users. A query definition consists of the query name and the name of the databases accessed by the query. All query directory files (
QD7files) have aQD7file extension.Results automatically creates a query directory for each user. The
QD7file for a user stores the queries created by that user. Results creates aQD7file for a user when the user starts Results and there is noQD7file for that user available in theresults.lor current working directory. The user query directory files are for only one user; they are not multi-user files. The name of aQD7file for a user takes the formuserid.qd7. For users who log into Results as the blank user ID, Results creates a genericQD7file calledresults.qd7. See the "User IDs" section for more information about user IDs.The public
QD7file serves as a storage place for queries shared by a number of Results users. The name of the public query directory ispublic.qd7, and this name is stored in the currentQC7file associated with the primary application database. There can be only one publicQD7file perQC7file.By default, Results creates the public
QD7files in the current working directory. Once Results creates aQD7file, you can move it anywhere in theresults.l.Results works with one query directory file at a time. When the user chooses Query
Save, Results writes the current query to the current
QD7file. A user can open a query from another query directory by choosing QueryOpen or save the current query into another query directory by choosing Query
Save As. These operations close a previously active query directory and make the query directory specified in the operation the current query directory in Results.
You can control access to the public query directory and other user query directories by setting feature security permissions on the ReadPublicDirectory, ReadOtherDirectory, WritePublicDirectory, and WriteOtherDirectory features. See the "Query directory security" section for more information about restricting access to user query directories.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |